1 DECLARE @
sql nvarchar(max),
4 SET @
sql = 'ALTER TABLE /*_*/recentchanges DROP CONSTRAINT ';--
7 FROM sys.default_constraints df
9 ON c.object_id
= df.parent_object_id
10 AND c.column_id
= df.parent_column_id
12 df.parent_object_id
= OBJECT_ID('/*_*/recentchanges')
13 AND c.
name = 'rc_cur_time';--
15 SET @
sql = @
sql + @
id;--
17 EXEC sp_executesql @
sql;--
19 ALTER TABLE /*_*/recentchanges
DROP COLUMN rc_cur_time
;